#!/bin/bash

mysql -h localhost -u root -p<<EOFMYSQL 
	CREATE DATABASE usb;
	use usb;
	CREATE TABLE Estudiante
	(
		name varchar(32),
		lastname varchar(32),
		carnet integer not null,
		CONSTRAINT carnet_pk
			PRIMARY KEY(carnet)
	);
	\. insert.sql
	CREATE TABLE Paciente
	(
	  	Nro integer,
		Id integer,		
		name varchar(32),
		lastname varchar(32),
		edad integer,
		CONSTRAINT carnet_pk
			PRIMARY KEY(Nro, Id)
	);
	quit
	EOFMYSQL
